Overview

Brought to you by YData

Dataset statistics

Number of variables	33
Number of observations	58,895
Missing cells	126,083
Missing cells (%)	6.5%
Duplicate rows	3,822
Duplicate rows (%)	6.5%
Total size in memory	14.8 MiB
Average record size in memory	264.0 B

Variable types

Categorical	15
Numeric	15
Text	1
Unsupported	1
DateTime	1

Alerts

Dataset has 3822 (6.5%) duplicate rows	Duplicates
`children` is highly imbalanced (79.9%)	Imbalance
`meal` is highly imbalanced (53.5%)	Imbalance
`distribution_channel` is highly imbalanced (59.7%)	Imbalance
`is_repeated_guest` is highly imbalanced (80.5%)	Imbalance
`reserved_room_type` is highly imbalanced (51.4%)	Imbalance
`deposit_type` is highly imbalanced (70.6%)	Imbalance
`required_car_parking_spaces` is highly imbalanced (80.2%)	Imbalance
`agent` has 9132 (15.5%) missing values	Missing
`company` has 55416 (94.1%) missing values	Missing
`customer_type` has 589 (1.0%) missing values	Missing
`required_car_parking_spaces` has 589 (1.0%) missing values	Missing
`reservation_status` has 589 (1.0%) missing values	Missing
`kids` has 58694 (99.7%) missing values	Missing
`adults` is highly skewed (γ1 = 24.81617275)	Skewed
`babies` is highly skewed (γ1 = 25.35395751)	Skewed
`previous_cancellations` is highly skewed (γ1 = 21.14836957)	Skewed
`company` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`lead_time` has 3700 (6.3%) zeros	Zeros
`stays_in_weekend_nights` has 23496 (39.9%) zeros	Zeros
`stays_in_week_nights` has 3603 (6.1%) zeros	Zeros
`babies` has 58094 (98.6%) zeros	Zeros
`previous_cancellations` has 57800 (98.1%) zeros	Zeros
`previous_bookings_not_canceled` has 56863 (96.5%) zeros	Zeros
`booking_changes` has 49268 (83.7%) zeros	Zeros
`days_in_waiting_list` has 56503 (95.9%) zeros	Zeros
`adr` has 954 (1.6%) zeros	Zeros
`total_of_special_requests` has 37158 (63.1%) zeros	Zeros

Reproduction

Analysis started	2025-09-21 06:35:16.139197
Analysis finished	2025-09-21 06:35:43.501166
Duration	27.36 seconds
Software version	ydata-profiling vv4.14.0
Download configuration	config.json

hotel
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.2 KiB

Resort Hotel	40063
City Hotel	18832

Length

Max length	12
Median length	12
Mean length	11.360489
Min length	10

Characters and Unicode

Total characters	669,076
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Resort Hotel
2nd row	Resort Hotel
3rd row	Resort Hotel
4th row	Resort Hotel
5th row	Resort Hotel

Common Values

Value	Count	Frequency (%)
Resort Hotel	40063	68.0%
City Hotel	18832	32.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hotel	58895	50.0%
resort	40063	34.0%
city	18832	16.0%

Most occurring characters

Value	Count	Frequency (%)
t	117790	17.6%
e	98958	14.8%
o	98958	14.8%
	58895	8.8%
H	58895	8.8%
l	58895	8.8%
R	40063	6.0%
s	40063	6.0%
r	40063	6.0%
C	18832	2.8%
Other values (2)	37664	5.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	669076	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	117790	17.6%
e	98958	14.8%
o	98958	14.8%
	58895	8.8%
H	58895	8.8%
l	58895	8.8%
R	40063	6.0%
s	40063	6.0%
r	40063	6.0%
C	18832	2.8%
Other values (2)	37664	5.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	669076	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	117790	17.6%
e	98958	14.8%
o	98958	14.8%
	58895	8.8%
H	58895	8.8%
l	58895	8.8%
R	40063	6.0%
s	40063	6.0%
r	40063	6.0%
C	18832	2.8%
Other values (2)	37664	5.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	669076	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	117790	17.6%
e	98958	14.8%
o	98958	14.8%
	58895	8.8%
H	58895	8.8%
l	58895	8.8%
R	40063	6.0%
s	40063	6.0%
r	40063	6.0%
C	18832	2.8%
Other values (2)	37664	5.6%

is_canceled
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.2 KiB

0	34666
1	24229

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	58,895
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	34666	58.9%
1	24229	41.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	34666	58.9%
1	24229	41.1%

Most occurring characters

Value	Count	Frequency (%)
0	34666	58.9%
1	24229	41.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	58895	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	34666	58.9%
1	24229	41.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	58895	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	34666	58.9%
1	24229	41.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	58895	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	34666	58.9%
1	24229	41.1%

lead_time
Real number (ℝ)

Zeros

Distinct	428
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	100.0509

Minimum	0
Maximum	737
Zeros	3700
Zeros (%)	6.3%
Negative	0
Negative (%)	0.0%
Memory size	460.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	17
median	69
Q3	157
95-th percentile	309
Maximum	737
Range	737
Interquartile range (IQR)	140

Descriptive statistics

Standard deviation	101.16242
Coefficient of variation (CV)	1.0111095
Kurtosis	1.0087856
Mean	100.0509
Median Absolute Deviation (MAD)	61
Skewness	1.2082573
Sum	5892498
Variance	10233.835
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3700	6.3%
1	1923	3.3%
2	1106	1.9%
3	941	1.6%
4	830	1.4%
5	745	1.3%
7	687	1.2%
6	672	1.1%
12	527	0.9%
10	519	0.9%
Other values (418)	47245	80.2%

Value	Count	Frequency (%)
0	3700	6.3%
1	1923	3.3%
2	1106	1.9%
3	941	1.6%
4	830	1.4%
5	745	1.3%
6	672	1.1%
7	687	1.2%
8	503	0.9%
9	477	0.8%

Value	Count	Frequency (%)
737	1	< 0.1%
709	1	< 0.1%
605	9	< 0.1%
542	23	< 0.1%
532	1	< 0.1%
471	6	< 0.1%
468	47	0.1%
462	20	< 0.1%
461	32	0.1%
460	3	< 0.1%

arrival_date_year
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	588
Missing (%)	1.0%
Memory size	460.2 KiB

2016.0	30105
2015.0	14537
2017.0	13051
20016.0	614

Length

Max length	7
Median length	6
Mean length	6.0105305
Min length	6

Characters and Unicode

Total characters	350,456
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2015.0
2nd row	2015.0
3rd row	2015.0
4th row	2015.0
5th row	2015.0

Common Values

Value	Count	Frequency (%)
2016.0	30105	51.1%
2015.0	14537	24.7%
2017.0	13051	22.2%
20016.0	614	1.0%
(Missing)	588	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2016.0	30105	51.6%
2015.0	14537	24.9%
2017.0	13051	22.4%
20016.0	614	1.1%

Most occurring characters

Value	Count	Frequency (%)
0	117228	33.5%
2	58307	16.6%
1	58307	16.6%
.	58307	16.6%
6	30719	8.8%
5	14537	4.1%
7	13051	3.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	350456	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	117228	33.5%
2	58307	16.6%
1	58307	16.6%
.	58307	16.6%
6	30719	8.8%
5	14537	4.1%
7	13051	3.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	350456	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	117228	33.5%
2	58307	16.6%
1	58307	16.6%
.	58307	16.6%
6	30719	8.8%
5	14537	4.1%
7	13051	3.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	350456	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	117228	33.5%
2	58307	16.6%
1	58307	16.6%
.	58307	16.6%
6	30719	8.8%
5	14537	4.1%
7	13051	3.7%

arrival_date_month
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.2 KiB

August	7715
September	6712
July	6177
October	6040
May	5283
Other values (7)	26968

Length

Max length	9
Median length	7
Mean length	6.0207148
Min length	3

Characters and Unicode

Total characters	354,590
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	July
2nd row	July
3rd row	July
4th row	July
5th row	July

Common Values

Value	Count	Frequency (%)
August	7715	13.1%
September	6712	11.4%
July	6177	10.5%
October	6040	10.3%
May	5283	9.0%
April	5185	8.8%
June	4725	8.0%
March	4492	7.6%
February	3830	6.5%
December	3121	5.3%
Other values (2)	5615	9.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
august	7715	13.1%
september	6712	11.4%
july	6177	10.5%
october	6040	10.3%
may	5283	9.0%
april	5185	8.8%
june	4725	8.0%
march	4492	7.6%
february	3830	6.5%
december	3121	5.3%
Other values (2)	5615	9.5%

Most occurring characters

Value	Count	Frequency (%)
e	49808	14.0%
r	38825	10.9%
u	32920	9.3%
b	22560	6.4%
t	20467	5.8%
a	19121	5.4%
y	18048	5.1%
J	13660	3.9%
c	13653	3.9%
A	12900	3.6%
Other values (16)	112628	31.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	354590	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	49808	14.0%
r	38825	10.9%
u	32920	9.3%
b	22560	6.4%
t	20467	5.8%
a	19121	5.4%
y	18048	5.1%
J	13660	3.9%
c	13653	3.9%
A	12900	3.6%
Other values (16)	112628	31.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	354590	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	49808	14.0%
r	38825	10.9%
u	32920	9.3%
b	22560	6.4%
t	20467	5.8%
a	19121	5.4%
y	18048	5.1%
J	13660	3.9%
c	13653	3.9%
A	12900	3.6%
Other values (16)	112628	31.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	354590	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	49808	14.0%
r	38825	10.9%
u	32920	9.3%
b	22560	6.4%
t	20467	5.8%
a	19121	5.4%
y	18048	5.1%
J	13660	3.9%
c	13653	3.9%
A	12900	3.6%
Other values (16)	112628	31.8%

arrival_date_week_number
Real number (ℝ)

Distinct	53
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.837389

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	460.2 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	17
median	29
Q3	38
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	13.346053
Coefficient of variation (CV)	0.47942904
Kurtosis	-0.94526161
Mean	27.837389
Median Absolute Deviation (MAD)	11
Skewness	-0.13277996
Sum	1639483
Variance	178.11712
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	2023	3.4%
34	1703	2.9%
41	1668	2.8%
38	1663	2.8%
32	1620	2.8%
42	1617	2.7%
37	1555	2.6%
40	1513	2.6%
35	1504	2.6%
30	1496	2.5%
Other values (43)	42533	72.2%

Value	Count	Frequency (%)
1	402	0.7%
2	573	1.0%
3	675	1.1%
4	687	1.2%
5	591	1.0%
6	802	1.4%
7	1073	1.8%
8	882	1.5%
9	950	1.6%
10	996	1.7%

Value	Count	Frequency (%)
53	807	1.4%
52	655	1.1%
51	467	0.8%
50	508	0.9%
49	844	1.4%
48	710	1.2%
47	814	1.4%
46	548	0.9%
45	750	1.3%
44	1000	1.7%

arrival_date_day_of_month
Real number (ℝ)

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.766432

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	460.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7830365
Coefficient of variation (CV)	0.55707192
Kurtosis	-1.1763513
Mean	15.766432
Median Absolute Deviation (MAD)	8
Skewness	0.021266696
Sum	928564
Variance	77.14173
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
5	2253	3.8%
12	2230	3.8%
16	2211	3.8%
18	2118	3.6%
17	2117	3.6%
30	2112	3.6%
26	2096	3.6%
9	2092	3.6%
15	2030	3.4%
25	2020	3.4%
Other values (21)	37616	63.9%

Value	Count	Frequency (%)
1	1750	3.0%
2	1997	3.4%
3	1850	3.1%
4	1850	3.1%
5	2253	3.8%
6	1782	3.0%
7	1846	3.1%
8	1908	3.2%
9	2092	3.6%
10	1718	2.9%

Value	Count	Frequency (%)
31	1186	2.0%
30	2112	3.6%
29	1712	2.9%
28	1820	3.1%
27	1711	2.9%
26	2096	3.6%
25	2020	3.4%
24	1978	3.4%
23	1767	3.0%
22	1810	3.1%

stays_in_weekend_nights
Real number (ℝ)

Zeros

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0581543

Minimum	0
Maximum	19
Zeros	23496
Zeros (%)	39.9%
Negative	0
Negative (%)	0.0%
Memory size	460.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	2
Maximum	19
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.0930323
Coefficient of variation (CV)	1.0329612
Kurtosis	7.4681056
Mean	1.0581543
Median Absolute Deviation (MAD)	1
Skewness	1.4335048
Sum	62320
Variance	1.1947197
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	23496	39.9%
2	18437	31.3%
1	14032	23.8%
4	1640	2.8%
3	1026	1.7%
6	128	0.2%
5	51	0.1%
8	42	0.1%
7	18	< 0.1%
9	8	< 0.1%
Other values (7)	17	< 0.1%

Value	Count	Frequency (%)
0	23496	39.9%
1	14032	23.8%
2	18437	31.3%
3	1026	1.7%
4	1640	2.8%
5	51	0.1%
6	128	0.2%
7	18	< 0.1%
8	42	0.1%
9	8	< 0.1%

Value	Count	Frequency (%)
19	1	< 0.1%
18	1	< 0.1%
16	2	< 0.1%
14	1	< 0.1%
13	2	< 0.1%
12	5	< 0.1%
10	5	< 0.1%
9	8	< 0.1%
8	42	0.1%
7	18	< 0.1%

stays_in_week_nights
Real number (ℝ)

Zeros

Distinct	33
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.8475762

Minimum	0
Maximum	50
Zeros	3603
Zeros (%)	6.1%
Negative	0
Negative (%)	0.0%
Memory size	460.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	6
Maximum	50
Range	50
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2354858
Coefficient of variation (CV)	0.78504864
Kurtosis	18.796619
Mean	2.8475762
Median Absolute Deviation (MAD)	1
Skewness	2.5680997
Sum	167708
Variance	4.9973969
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
2	14539	24.7%
1	13621	23.1%
3	9677	16.4%
5	8524	14.5%
4	4862	8.3%
0	3603	6.1%
6	1220	2.1%
10	936	1.6%
7	887	1.5%
8	532	0.9%
Other values (23)	494	0.8%

Value	Count	Frequency (%)
0	3603	6.1%
1	13621	23.1%
2	14539	24.7%
3	9677	16.4%
4	4862	8.3%
5	8524	14.5%
6	1220	2.1%
7	887	1.5%
8	532	0.9%
9	179	0.3%

Value	Count	Frequency (%)
50	1	< 0.1%
42	1	< 0.1%
40	2	< 0.1%
34	1	< 0.1%
33	1	< 0.1%
32	1	< 0.1%
30	4	< 0.1%
26	1	< 0.1%
25	5	< 0.1%
24	1	< 0.1%

adults
Real number (ℝ)

Skewed

Distinct	54
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9691485

Minimum	-1
Maximum	100
Zeros	104
Zeros (%)	0.2%
Negative	99
Negative (%)	0.2%
Memory size	460.2 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	2
Maximum	100
Range	101
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.9434539
Coefficient of variation (CV)	1.4947851
Kurtosis	657.97785
Mean	1.9691485
Median Absolute Deviation (MAD)	0
Skewness	24.816173
Sum	115973
Variance	8.6639207
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	45712	77.6%
1	10610	18.0%
3	2225	3.8%
0	104	0.2%
-1	99	0.2%
4	34	0.1%
66	6	< 0.1%
65	5	< 0.1%
26	5	< 0.1%
69	4	< 0.1%
Other values (44)	91	0.2%

Value	Count	Frequency (%)
-1	99	0.2%
0	104	0.2%
1	10610	18.0%
2	45712	77.6%
3	2225	3.8%
4	34	0.1%
5	2	< 0.1%
6	1	< 0.1%
10	1	< 0.1%
20	2	< 0.1%

Value	Count	Frequency (%)
100	3	< 0.1%
98	2	< 0.1%
96	2	< 0.1%
95	3	< 0.1%
93	1	< 0.1%
92	2	< 0.1%
91	4	< 0.1%
89	1	< 0.1%
87	1	< 0.1%
86	2	< 0.1%

children
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	4
Missing (%)	< 0.1%
Memory size	460.2 KiB

0.0	54415
1.0	2335
2.0	2114
3.0	26
10.0	1

Length

Max length	4
Median length	3
Mean length	3.000017
Min length	3

Characters and Unicode

Total characters	176,674
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	54415	92.4%
1.0	2335	4.0%
2.0	2114	3.6%
3.0	26	< 0.1%
10.0	1	< 0.1%
(Missing)	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	54415	92.4%
1.0	2335	4.0%
2.0	2114	3.6%
3.0	26	< 0.1%
10.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	113307	64.1%
.	58891	33.3%
1	2336	1.3%
2	2114	1.2%
3	26	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	176674	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	113307	64.1%
.	58891	33.3%
1	2336	1.3%
2	2114	1.2%
3	26	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	176674	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	113307	64.1%
.	58891	33.3%
1	2336	1.3%
2	2114	1.2%
3	26	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	176674	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	113307	64.1%
.	58891	33.3%
1	2336	1.3%
2	2114	1.2%
3	26	< 0.1%

babies
Real number (ℝ)

Skewed Zeros

Distinct	47
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.13659903

Minimum	-1
Maximum	100
Zeros	58094
Zeros (%)	98.6%
Negative	90
Negative (%)	0.2%
Memory size	460.2 KiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	100
Range	101
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.1158893
Coefficient of variation (CV)	22.810478
Kurtosis	665.69282
Mean	0.13659903
Median Absolute Deviation (MAD)	0
Skewness	25.353958
Sum	8045
Variance	9.7087659
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	58094	98.6%
1	598	1.0%
-1	90	0.2%
2	9	< 0.1%
51	6	< 0.1%
57	5	< 0.1%
77	5	< 0.1%
73	5	< 0.1%
81	4	< 0.1%
94	4	< 0.1%
Other values (37)	75	0.1%

Value	Count	Frequency (%)
-1	90	0.2%
0	58094	98.6%
1	598	1.0%
2	9	< 0.1%
10	1	< 0.1%
50	1	< 0.1%
51	6	< 0.1%
52	2	< 0.1%
53	2	< 0.1%
54	1	< 0.1%

Value	Count	Frequency (%)
100	2	< 0.1%
99	2	< 0.1%
98	2	< 0.1%
97	4	< 0.1%
96	2	< 0.1%
95	1	< 0.1%
94	4	< 0.1%
93	3	< 0.1%
92	3	< 0.1%
91	1	< 0.1%

meal
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.2 KiB

BB	45060
HB	10096
SC	1780
Undefined	1169
FB	790

Length

Max length	9
Median length	2
Mean length	2.1389422
Min length	2

Characters and Unicode

Total characters	125,973
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BB
2nd row	BB
3rd row	BB
4th row	BB
5th row	BB

Common Values

Value	Count	Frequency (%)
BB	45060	76.5%
HB	10096	17.1%
SC	1780	3.0%
Undefined	1169	2.0%
FB	790	1.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bb	45060	76.5%
hb	10096	17.1%
sc	1780	3.0%
undefined	1169	2.0%
fb	790	1.3%

Most occurring characters

Value	Count	Frequency (%)
B	101006	80.2%
H	10096	8.0%
n	2338	1.9%
d	2338	1.9%
e	2338	1.9%
S	1780	1.4%
C	1780	1.4%
U	1169	0.9%
f	1169	0.9%
i	1169	0.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	125973	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	101006	80.2%
H	10096	8.0%
n	2338	1.9%
d	2338	1.9%
e	2338	1.9%
S	1780	1.4%
C	1780	1.4%
U	1169	0.9%
f	1169	0.9%
i	1169	0.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	125973	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	101006	80.2%
H	10096	8.0%
n	2338	1.9%
d	2338	1.9%
e	2338	1.9%
S	1780	1.4%
C	1780	1.4%
U	1169	0.9%
f	1169	0.9%
i	1169	0.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	125973	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	101006	80.2%
H	10096	8.0%
n	2338	1.9%
d	2338	1.9%
e	2338	1.9%
S	1780	1.4%
C	1780	1.4%
U	1169	0.9%
f	1169	0.9%
i	1169	0.9%

country
Text

Distinct	141
Distinct (%)	0.2%
Missing	478
Missing (%)	0.8%
Memory size	460.2 KiB

Length

Max length	3
Median length	3
Mean length	2.9861855
Min length	2

Characters and Unicode

Total characters	174,444
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	28 ?
Unique (%)	< 0.1%

Sample

1st row	PRT
2nd row	PRT
3rd row	GBR
4th row	GBR
5th row	GBR

Value	Count	Frequency (%)
prt	27559	47.2%
gbr	7595	13.0%
esp	5275	9.0%
fra	3037	5.2%
irl	2371	4.1%
deu	2022	3.5%
ita	1290	2.2%
cn	807	1.4%
nld	748	1.3%
bel	733	1.3%
Other values (131)	6980	11.9%

Most occurring characters

Value	Count	Frequency (%)
R	42796	24.5%
P	33418	19.2%
T	29542	16.9%
E	9298	5.3%
B	9147	5.2%
G	7985	4.6%
S	7221	4.1%
A	6903	4.0%
L	4699	2.7%
U	4268	2.4%
Other values (16)	19167	11.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	174444	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
R	42796	24.5%
P	33418	19.2%
T	29542	16.9%
E	9298	5.3%
B	9147	5.2%
G	7985	4.6%
S	7221	4.1%
A	6903	4.0%
L	4699	2.7%
U	4268	2.4%
Other values (16)	19167	11.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	174444	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
R	42796	24.5%
P	33418	19.2%
T	29542	16.9%
E	9298	5.3%
B	9147	5.2%
G	7985	4.6%
S	7221	4.1%
A	6903	4.0%
L	4699	2.7%
U	4268	2.4%
Other values (16)	19167	11.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	174444	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
R	42796	24.5%
P	33418	19.2%
T	29542	16.9%
E	9298	5.3%
B	9147	5.2%
G	7985	4.6%
S	7221	4.1%
A	6903	4.0%
L	4699	2.7%
U	4268	2.4%
Other values (16)	19167	11.0%

market_segment
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.2 KiB

Online TA	25742
Offline TA/TO	12455
Groups	10399
Direct	7400
Corporate	2621
Other values (3)	278

Length

Max length	13
Median length	9
Mean length	8.9561423
Min length	6

Characters and Unicode

Total characters	527,472
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct
2nd row	Direct
3rd row	Direct
4th row	Corporate
5th row	Online TA

Common Values

Value	Count	Frequency (%)
Online TA	25742	43.7%
Offline TA/TO	12455	21.1%
Groups	10399	17.7%
Direct	7400	12.6%
Corporate	2621	4.5%
Complementary	254	0.4%
Aviation	22	< 0.1%
Undefined	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
online	25742	26.5%
ta	25742	26.5%
offline	12455	12.8%
ta/to	12455	12.8%
groups	10399	10.7%
direct	7400	7.6%
corporate	2621	2.7%
complementary	254	0.3%
aviation	22	< 0.1%
undefined	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
n	64219	12.2%
O	50652	9.6%
T	50652	9.6%
e	48730	9.2%
i	45643	8.7%
l	38451	7.3%
A	38219	7.2%
	38197	7.2%
f	24912	4.7%
r	23295	4.4%
Other values (16)	104502	19.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	527472	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	64219	12.2%
O	50652	9.6%
T	50652	9.6%
e	48730	9.2%
i	45643	8.7%
l	38451	7.3%
A	38219	7.2%
	38197	7.2%
f	24912	4.7%
r	23295	4.4%
Other values (16)	104502	19.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	527472	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	64219	12.2%
O	50652	9.6%
T	50652	9.6%
e	48730	9.2%
i	45643	8.7%
l	38451	7.3%
A	38219	7.2%
	38197	7.2%
f	24912	4.7%
r	23295	4.4%
Other values (16)	104502	19.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	527472	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	64219	12.2%
O	50652	9.6%
T	50652	9.6%
e	48730	9.2%
i	45643	8.7%
l	38451	7.3%
A	38219	7.2%
	38197	7.2%
f	24912	4.7%
r	23295	4.4%
Other values (16)	104502	19.8%

distribution_channel
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.2 KiB

TA/TO	46358
Direct	8841
Corporate	3680
GDS	11
Undefined	5

Length

Max length	9
Median length	5
Mean length	5.400017
Min length	3

Characters and Unicode

Total characters	318,034
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Direct
2nd row	Direct
3rd row	Direct
4th row	Corporate
5th row	TA/TO

Common Values

Value	Count	Frequency (%)
TA/TO	46358	78.7%
Direct	8841	15.0%
Corporate	3680	6.2%
GDS	11	< 0.1%
Undefined	5	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ta/to	46358	78.7%
direct	8841	15.0%
corporate	3680	6.2%
gds	11	< 0.1%
undefined	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
T	92716	29.2%
/	46358	14.6%
O	46358	14.6%
A	46358	14.6%
r	16201	5.1%
e	12531	3.9%
t	12521	3.9%
D	8852	2.8%
i	8846	2.8%
c	8841	2.8%
Other values (10)	18452	5.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	318034	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
T	92716	29.2%
/	46358	14.6%
O	46358	14.6%
A	46358	14.6%
r	16201	5.1%
e	12531	3.9%
t	12521	3.9%
D	8852	2.8%
i	8846	2.8%
c	8841	2.8%
Other values (10)	18452	5.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	318034	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
T	92716	29.2%
/	46358	14.6%
O	46358	14.6%
A	46358	14.6%
r	16201	5.1%
e	12531	3.9%
t	12521	3.9%
D	8852	2.8%
i	8846	2.8%
c	8841	2.8%
Other values (10)	18452	5.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	318034	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
T	92716	29.2%
/	46358	14.6%
O	46358	14.6%
A	46358	14.6%
r	16201	5.1%
e	12531	3.9%
t	12521	3.9%
D	8852	2.8%
i	8846	2.8%
c	8841	2.8%
Other values (10)	18452	5.8%

is_repeated_guest
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.2 KiB

0	57117
1	1778

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	58,895
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	57117	97.0%
1	1778	3.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	57117	97.0%
1	1778	3.0%

Most occurring characters

Value	Count	Frequency (%)
0	57117	97.0%
1	1778	3.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	58895	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	57117	97.0%
1	1778	3.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	58895	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	57117	97.0%
1	1778	3.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	58895	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	57117	97.0%
1	1778	3.0%

previous_cancellations
Real number (ℝ)

Skewed Zeros

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.069190933

Minimum	0
Maximum	26
Zeros	57800
Zeros (%)	98.1%
Negative	0
Negative (%)	0.0%
Memory size	460.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	26
Range	26
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.1021382
Coefficient of variation (CV)	15.928939
Kurtosis	458.83288
Mean	0.069190933
Median Absolute Deviation (MAD)	0
Skewness	21.14837
Sum	4075
Variance	1.2147086
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	57800	98.1%
1	896	1.5%
24	48	0.1%
2	44	0.1%
26	26	< 0.1%
25	25	< 0.1%
19	19	< 0.1%
3	14	< 0.1%
14	14	< 0.1%
4	6	< 0.1%

Value	Count	Frequency (%)
0	57800	98.1%
1	896	1.5%
2	44	0.1%
3	14	< 0.1%
4	6	< 0.1%
5	3	< 0.1%
14	14	< 0.1%
19	19	< 0.1%
24	48	0.1%
25	25	< 0.1%

Value	Count	Frequency (%)
26	26	< 0.1%
25	25	< 0.1%
24	48	0.1%
19	19	< 0.1%
14	14	< 0.1%
5	3	< 0.1%
4	6	< 0.1%
3	14	< 0.1%
2	44	0.1%
1	896	1.5%

previous_bookings_not_canceled
Real number (ℝ)

Zeros

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.099617964

Minimum	0
Maximum	30
Zeros	56863
Zeros (%)	96.5%
Negative	0
Negative (%)	0.0%
Memory size	460.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	30
Range	30
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.82916558
Coefficient of variation (CV)	8.3234544
Kurtosis	359.36435
Mean	0.099617964
Median Absolute Deviation (MAD)	0
Skewness	16.059944
Sum	5867
Variance	0.68751556
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
0	56863	96.5%
1	973	1.7%
2	388	0.7%
3	204	0.3%
4	127	0.2%
5	91	0.2%
6	56	0.1%
7	37	0.1%
8	33	0.1%
9	24	< 0.1%
Other values (21)	99	0.2%

Value	Count	Frequency (%)
0	56863	96.5%
1	973	1.7%
2	388	0.7%
3	204	0.3%
4	127	0.2%
5	91	0.2%
6	56	0.1%
7	37	0.1%
8	33	0.1%
9	24	< 0.1%

Value	Count	Frequency (%)
30	1	< 0.1%
29	1	< 0.1%
28	1	< 0.1%
27	2	< 0.1%
26	1	< 0.1%
25	3	< 0.1%
24	2	< 0.1%
23	2	< 0.1%
22	2	< 0.1%
21	2	< 0.1%

reserved_room_type
Categorical

Imbalance

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.2 KiB

A	39143
D	9516
E	5143
G	1649
F	1515
Other values (5)	1929

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	58,895
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C
2nd row	C
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	39143	66.5%
D	9516	16.2%
E	5143	8.7%
G	1649	2.8%
F	1515	2.6%
C	920	1.6%
H	601	1.0%
B	400	0.7%
L	6	< 0.1%
P	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	39143	66.5%
d	9516	16.2%
e	5143	8.7%
g	1649	2.8%
f	1515	2.6%
c	920	1.6%
h	601	1.0%
b	400	0.7%
l	6	< 0.1%
p	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	39143	66.5%
D	9516	16.2%
E	5143	8.7%
G	1649	2.8%
F	1515	2.6%
C	920	1.6%
H	601	1.0%
B	400	0.7%
L	6	< 0.1%
P	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	58895	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	39143	66.5%
D	9516	16.2%
E	5143	8.7%
G	1649	2.8%
F	1515	2.6%
C	920	1.6%
H	601	1.0%
B	400	0.7%
L	6	< 0.1%
P	2	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	58895	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	39143	66.5%
D	9516	16.2%
E	5143	8.7%
G	1649	2.8%
F	1515	2.6%
C	920	1.6%
H	601	1.0%
B	400	0.7%
L	6	< 0.1%
P	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	58895	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	39143	66.5%
D	9516	16.2%
E	5143	8.7%
G	1649	2.8%
F	1515	2.6%
C	920	1.6%
H	601	1.0%
B	400	0.7%
L	6	< 0.1%
P	2	< 0.1%

assigned_room_type
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.2 KiB

A	31391
D	13336
E	5927
C	2225
F	2177
Other values (7)	3839

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	58,895
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	C
2nd row	C
3rd row	C
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	31391	53.3%
D	13336	22.6%
E	5927	10.1%
C	2225	3.8%
F	2177	3.7%
G	1917	3.3%
B	821	1.4%
H	712	1.2%
I	363	0.6%
K	23	< 0.1%
Other values (2)	3	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a	31391	53.3%
d	13336	22.6%
e	5927	10.1%
c	2225	3.8%
f	2177	3.7%
g	1917	3.3%
b	821	1.4%
h	712	1.2%
i	363	0.6%
k	23	< 0.1%
Other values (2)	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	31391	53.3%
D	13336	22.6%
E	5927	10.1%
C	2225	3.8%
F	2177	3.7%
G	1917	3.3%
B	821	1.4%
H	712	1.2%
I	363	0.6%
K	23	< 0.1%
Other values (2)	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	58895	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	31391	53.3%
D	13336	22.6%
E	5927	10.1%
C	2225	3.8%
F	2177	3.7%
G	1917	3.3%
B	821	1.4%
H	712	1.2%
I	363	0.6%
K	23	< 0.1%
Other values (2)	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	58895	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	31391	53.3%
D	13336	22.6%
E	5927	10.1%
C	2225	3.8%
F	2177	3.7%
G	1917	3.3%
B	821	1.4%
H	712	1.2%
I	363	0.6%
K	23	< 0.1%
Other values (2)	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	58895	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	31391	53.3%
D	13336	22.6%
E	5927	10.1%
C	2225	3.8%
F	2177	3.7%
G	1917	3.3%
B	821	1.4%
H	712	1.2%
I	363	0.6%
K	23	< 0.1%
Other values (2)	3	< 0.1%

booking_changes
Real number (ℝ)

Zeros

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.24300874

Minimum	0
Maximum	20
Zeros	49268
Zeros (%)	83.7%
Negative	0
Negative (%)	0.0%
Memory size	460.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	20
Range	20
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.695205
Coefficient of variation (CV)	2.860823
Kurtosis	68.966364
Mean	0.24300874
Median Absolute Deviation (MAD)	0
Skewness	5.7511422
Sum	14312
Variance	0.48331
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	49268	83.7%
1	6755	11.5%
2	1921	3.3%
3	553	0.9%
4	220	0.4%
5	81	0.1%
6	42	0.1%
7	21	< 0.1%
8	11	< 0.1%
9	7	< 0.1%
Other values (8)	16	< 0.1%

Value	Count	Frequency (%)
0	49268	83.7%
1	6755	11.5%
2	1921	3.3%
3	553	0.9%
4	220	0.4%
5	81	0.1%
6	42	0.1%
7	21	< 0.1%
8	11	< 0.1%
9	7	< 0.1%

Value	Count	Frequency (%)
20	1	< 0.1%
17	2	< 0.1%
16	1	< 0.1%
15	2	< 0.1%
14	1	< 0.1%
13	5	< 0.1%
12	1	< 0.1%
10	3	< 0.1%
9	7	< 0.1%
8	11	< 0.1%

deposit_type
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	460.2 KiB

No Deposit	52333
Non Refund	5457
No Refund	962
Refundable	143

Length

Max length	10
Median length	10
Mean length	9.9836658
Min length	9

Characters and Unicode

Total characters	587,988
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Deposit
2nd row	No Deposit
3rd row	No Deposit
4th row	No Deposit
5th row	No Deposit

Common Values

Value	Count	Frequency (%)
No Deposit	52333	88.9%
Non Refund	5457	9.3%
No Refund	962	1.6%
Refundable	143	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	53295	45.3%
deposit	52333	44.5%
refund	6419	5.5%
non	5457	4.6%
refundable	143	0.1%

Most occurring characters

Value	Count	Frequency (%)
o	111085	18.9%
e	59038	10.0%
N	58752	10.0%
	58752	10.0%
s	52333	8.9%
i	52333	8.9%
t	52333	8.9%
p	52333	8.9%
D	52333	8.9%
n	12019	2.0%
Other values (7)	26677	4.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	587988	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	111085	18.9%
e	59038	10.0%
N	58752	10.0%
	58752	10.0%
s	52333	8.9%
i	52333	8.9%
t	52333	8.9%
p	52333	8.9%
D	52333	8.9%
n	12019	2.0%
Other values (7)	26677	4.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	587988	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	111085	18.9%
e	59038	10.0%
N	58752	10.0%
	58752	10.0%
s	52333	8.9%
i	52333	8.9%
t	52333	8.9%
p	52333	8.9%
D	52333	8.9%
n	12019	2.0%
Other values (7)	26677	4.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	587988	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	111085	18.9%
e	59038	10.0%
N	58752	10.0%
	58752	10.0%
s	52333	8.9%
i	52333	8.9%
t	52333	8.9%
p	52333	8.9%
D	52333	8.9%
n	12019	2.0%
Other values (7)	26677	4.5%

agent
Real number (ℝ)

Missing

Distinct	249
Distinct (%)	0.5%
Missing	9132
Missing (%)	15.5%
Infinite	0
Infinite (%)	0.0%
Mean	146.98308

Minimum	1
Maximum	535
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	460.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	9
median	196
Q3	240
95-th percentile	314
Maximum	535
Range	534
Interquartile range (IQR)	231

Descriptive statistics

Standard deviation	120.11499
Coefficient of variation (CV)	0.81720282
Kurtosis	-1.0837932
Mean	146.98308
Median Absolute Deviation (MAD)	81
Skewness	0.11667503
Sum	7314319
Variance	14427.61
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
240	13907	23.6%
9	6997	11.9%
1	3184	5.4%
250	2870	4.9%
241	1721	2.9%
6	1378	2.3%
40	1013	1.7%
314	927	1.6%
242	779	1.3%
37	615	1.0%
Other values (239)	16372	27.8%
(Missing)	9132	15.5%

Value	Count	Frequency (%)
1	3184	5.4%
2	120	0.2%
3	564	1.0%
5	256	0.4%
6	1378	2.3%
7	481	0.8%
8	558	0.9%
9	6997	11.9%
10	39	0.1%
11	225	0.4%

Value	Count	Frequency (%)
535	3	< 0.1%
531	68	0.1%
527	35	0.1%
526	10	< 0.1%
510	2	< 0.1%
508	6	< 0.1%
502	24	< 0.1%
497	1	< 0.1%
495	50	0.1%
493	35	0.1%

company
Unsupported

Missing Rejected Unsupported

Missing	55416
Missing (%)	94.1%
Memory size	460.2 KiB

days_in_waiting_list
Real number (ℝ)

Zeros

Distinct	99
Distinct (%)	0.2%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	3.5259789

Minimum	0
Maximum	391
Zeros	56503
Zeros (%)	95.9%
Negative	0
Negative (%)	0.0%
Memory size	460.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	391
Range	391
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	21.841676
Coefficient of variation (CV)	6.1945001
Kurtosis	101.43631
Mean	3.5259789
Median Absolute Deviation (MAD)	0
Skewness	8.9202327
Sum	207659
Variance	477.05883
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	56503	95.9%
39	186	0.3%
58	164	0.3%
31	102	0.2%
69	89	0.2%
87	80	0.1%
63	80	0.1%
111	70	0.1%
101	65	0.1%
77	63	0.1%
Other values (89)	1492	2.5%

Value	Count	Frequency (%)
0	56503	95.9%
1	7	< 0.1%
2	2	< 0.1%
3	59	0.1%
4	10	< 0.1%
5	4	< 0.1%
6	4	< 0.1%
8	6	< 0.1%
11	1	< 0.1%
13	2	< 0.1%

Value	Count	Frequency (%)
391	15	< 0.1%
379	15	< 0.1%
330	15	< 0.1%
259	10	< 0.1%
236	35	0.1%
224	10	< 0.1%
223	60	0.1%
215	21	< 0.1%
207	15	< 0.1%
187	45	0.1%

customer_type
Categorical

Missing

Distinct	4
Distinct (%)	< 0.1%
Missing	589
Missing (%)	1.0%
Memory size	460.2 KiB

Transient	42430
Transient-Party	13078
Contract	2486
Group	312

Length

Max length	15
Median length	9
Mean length	10.281755
Min length	5

Characters and Unicode

Total characters	599,488
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Transient
2nd row	Transient
3rd row	Transient
4th row	Transient
5th row	Transient

Common Values

Value	Count	Frequency (%)
Transient	42430	72.0%
Transient-Party	13078	22.2%
Contract	2486	4.2%
Group	312	0.5%
(Missing)	589	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
transient	42430	72.8%
transient-party	13078	22.4%
contract	2486	4.3%
group	312	0.5%

Most occurring characters

Value	Count	Frequency (%)
n	113502	18.9%
t	73558	12.3%
r	71384	11.9%
a	71072	11.9%
T	55508	9.3%
s	55508	9.3%
i	55508	9.3%
e	55508	9.3%
y	13078	2.2%
-	13078	2.2%
Other values (7)	21784	3.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	599488	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	113502	18.9%
t	73558	12.3%
r	71384	11.9%
a	71072	11.9%
T	55508	9.3%
s	55508	9.3%
i	55508	9.3%
e	55508	9.3%
y	13078	2.2%
-	13078	2.2%
Other values (7)	21784	3.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	599488	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	113502	18.9%
t	73558	12.3%
r	71384	11.9%
a	71072	11.9%
T	55508	9.3%
s	55508	9.3%
i	55508	9.3%
e	55508	9.3%
y	13078	2.2%
-	13078	2.2%
Other values (7)	21784	3.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	599488	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	113502	18.9%
t	73558	12.3%
r	71384	11.9%
a	71072	11.9%
T	55508	9.3%
s	55508	9.3%
i	55508	9.3%
e	55508	9.3%
y	13078	2.2%
-	13078	2.2%
Other values (7)	21784	3.6%

adr
Real number (ℝ)

Zeros

Distinct	6769
Distinct (%)	11.5%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	96.250426

Minimum	-6.38
Maximum	5400
Zeros	954
Zeros (%)	1.6%
Negative	1
Negative (%)	< 0.1%
Memory size	460.2 KiB

Quantile statistics

Minimum	-6.38
5-th percentile	34.02
Q1	60
median	84
Q3	120
95-th percentile	207.618
Maximum	5400
Range	5406.38
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	58.555599
Coefficient of variation (CV)	0.60836716
Kurtosis	1143.6777
Mean	96.250426
Median Absolute Deviation (MAD)	29
Skewness	13.602849
Sum	5668572.6
Variance	3428.7582
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	1786	3.0%
75	1077	1.8%
48	1037	1.8%
0	954	1.6%
65	940	1.6%
60	803	1.4%
90	734	1.2%
120	703	1.2%
80	701	1.2%
70	663	1.1%
Other values (6759)	49496	84.0%

Value	Count	Frequency (%)
-6.38	1	< 0.1%
0	954	1.6%
0.26	1	< 0.1%
0.5	1	< 0.1%
1	3	< 0.1%
1.56	2	< 0.1%
1.8	1	< 0.1%
2	8	< 0.1%
2.4	1	< 0.1%
3	1	< 0.1%

Value	Count	Frequency (%)
5400	1	< 0.1%
508	1	< 0.1%
450	1	< 0.1%
437	1	< 0.1%
426.25	1	< 0.1%
402	1	< 0.1%
397.38	1	< 0.1%
392	2	< 0.1%
388	2	< 0.1%
387	1	< 0.1%

required_car_parking_spaces
Categorical

Imbalance Missing

Distinct	5
Distinct (%)	< 0.1%
Missing	589
Missing (%)	1.0%
Memory size	460.2 KiB

0.0	52709
1.0	5569
2.0	25
8.0	2
3.0	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	174,918
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	52709	89.5%
1.0	5569	9.5%
2.0	25	< 0.1%
8.0	2	< 0.1%
3.0	1	< 0.1%
(Missing)	589	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	52709	90.4%
1.0	5569	9.6%
2.0	25	< 0.1%
8.0	2	< 0.1%
3.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	111015	63.5%
.	58306	33.3%
1	5569	3.2%
2	25	< 0.1%
8	2	< 0.1%
3	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	174918	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	111015	63.5%
.	58306	33.3%
1	5569	3.2%
2	25	< 0.1%
8	2	< 0.1%
3	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	174918	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	111015	63.5%
.	58306	33.3%
1	5569	3.2%
2	25	< 0.1%
8	2	< 0.1%
3	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	174918	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	111015	63.5%
.	58306	33.3%
1	5569	3.2%
2	25	< 0.1%
8	2	< 0.1%
3	1	< 0.1%

total_of_special_requests
Real number (ℝ)

Zeros

Distinct	6
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.51222535

Minimum	0
Maximum	5
Zeros	37158
Zeros (%)	63.1%
Negative	0
Negative (%)	0.0%
Memory size	460.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.7683779
Coefficient of variation (CV)	1.5000778
Kurtosis	1.8884772
Mean	0.51222535
Median Absolute Deviation (MAD)	0
Skewness	1.4897608
Sum	30167
Variance	0.59040459
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	37158	63.1%
1	14711	25.0%
2	5796	9.8%
3	1066	1.8%
4	149	0.3%
5	14	< 0.1%
(Missing)	1	< 0.1%

Value	Count	Frequency (%)
0	37158	63.1%
1	14711	25.0%
2	5796	9.8%
3	1066	1.8%
4	149	0.3%
5	14	< 0.1%

Value	Count	Frequency (%)
5	14	< 0.1%
4	149	0.3%
3	1066	1.8%
2	5796	9.8%
1	14711	25.0%
0	37158	63.1%

reservation_status
Categorical

Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	589
Missing (%)	1.0%
Memory size	460.2 KiB

Check-Out	34291
Canceled	23218
No-Show	797

Length

Max length	9
Median length	9
Mean length	8.574452
Min length	7

Characters and Unicode

Total characters	499,942
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Check-Out
2nd row	Check-Out
3rd row	Check-Out
4th row	Check-Out
5th row	Check-Out

Common Values

Value	Count	Frequency (%)
Check-Out	34291	58.2%
Canceled	23218	39.4%
No-Show	797	1.4%
(Missing)	589	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
check-out	34291	58.8%
canceled	23218	39.8%
no-show	797	1.4%

Most occurring characters

Value	Count	Frequency (%)
e	80727	16.1%
C	57509	11.5%
c	57509	11.5%
h	35088	7.0%
-	35088	7.0%
u	34291	6.9%
t	34291	6.9%
O	34291	6.9%
k	34291	6.9%
a	23218	4.6%
Other values (7)	73639	14.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	499942	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	80727	16.1%
C	57509	11.5%
c	57509	11.5%
h	35088	7.0%
-	35088	7.0%
u	34291	6.9%
t	34291	6.9%
O	34291	6.9%
k	34291	6.9%
a	23218	4.6%
Other values (7)	73639	14.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	499942	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	80727	16.1%
C	57509	11.5%
c	57509	11.5%
h	35088	7.0%
-	35088	7.0%
u	34291	6.9%
t	34291	6.9%
O	34291	6.9%
k	34291	6.9%
a	23218	4.6%
Other values (7)	73639	14.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	499942	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	80727	16.1%
C	57509	11.5%
c	57509	11.5%
h	35088	7.0%
-	35088	7.0%
u	34291	6.9%
t	34291	6.9%
O	34291	6.9%
k	34291	6.9%
a	23218	4.6%
Other values (7)	73639	14.7%

reservation_status_date
Date

Distinct	921
Distinct (%)	1.6%
Missing	1
Missing (%)	< 0.1%
Memory size	460.2 KiB

Minimum	2014-11-18 00:00:00
Maximum	2017-09-14 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

kids
Real number (ℝ)

Missing

Distinct	41
Distinct (%)	20.4%
Missing	58694
Missing (%)	99.7%
Infinite	0
Infinite (%)	0.0%
Mean	34.41791

Minimum	-1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	105
Negative (%)	0.2%
Memory size	460.2 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-1
median	-1
Q3	65
95-th percentile	96
Maximum	100
Range	101
Interquartile range (IQR)	66

Descriptive statistics

Standard deviation	38.571032
Coefficient of variation (CV)	1.1206674
Kurtosis	-1.6413267
Mean	34.41791
Median Absolute Deviation (MAD)	0
Skewness	0.31316079
Sum	6918
Variance	1487.7245
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
-1	105	0.2%
62	6	< 0.1%
60	5	< 0.1%
63	5	< 0.1%
58	5	< 0.1%
57	5	< 0.1%
100	3	< 0.1%
80	3	< 0.1%
98	3	< 0.1%
59	3	< 0.1%
Other values (31)	58	0.1%
(Missing)	58694	99.7%

Value	Count	Frequency (%)
-1	105	0.2%
52	2	< 0.1%
53	3	< 0.1%
54	1	< 0.1%
55	1	< 0.1%
56	2	< 0.1%
57	5	< 0.1%
58	5	< 0.1%
59	3	< 0.1%
60	5	< 0.1%

Value	Count	Frequency (%)
100	3	< 0.1%
98	3	< 0.1%
97	3	< 0.1%
96	3	< 0.1%
95	3	< 0.1%
93	1	< 0.1%
92	1	< 0.1%
89	2	< 0.1%
88	1	< 0.1%
87	1	< 0.1%

Interactions

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	booking_changes	deposit_type	agent	company	customer_type	adr	total_of_special_requests	reservation_status	reservation_status_date	kids
0	Resort Hotel	0	342	2015.0	July	27	1	0	2	BB	PRT	Direct	Direct	C	C	3	No Deposit	NaN	NaN	Transient	0.0	0.0	Check-Out	2015-07-01	NaN
1	Resort Hotel	0	737	2015.0	July	27	1	0	2	BB	PRT	Direct	Direct	C	C	4	No Deposit	NaN	NaN	Transient	0.0	0.0	Check-Out	2015-07-01	NaN
2	Resort Hotel	0	7	2015.0	July	27	1	1	1	BB	GBR	Direct	Direct	A	C	0	No Deposit	NaN	NaN	Transient	75.0	0.0	Check-Out	2015-07-02	NaN
3	Resort Hotel	0	13	2015.0	July	27	1	1	1	BB	GBR	Corporate	Corporate	A	A	0	No Deposit	304.0	NaN	Transient	75.0	0.0	Check-Out	2015-07-02	NaN
4	Resort Hotel	0	14	2015.0	July	27	1	2	2	BB	GBR	Online TA	TA/TO	A	A	0	No Deposit	240.0	NaN	Transient	98.0	1.0	Check-Out	2015-07-03	NaN
5	Resort Hotel	0	14	2015.0	July	27	1	2	2	BB	GBR	Online TA	TA/TO	A	A	0	No Deposit	240.0	NaN	Transient	98.0	1.0	Check-Out	2015-07-03	NaN
6	Resort Hotel	0	0	2015.0	July	27	1	2	2	BB	PRT	Direct	Direct	C	C	0	No Deposit	NaN	NaN	Transient	107.0	0.0	Check-Out	2015-07-03	NaN
7	Resort Hotel	0	9	2015.0	July	27	1	2	2	FB	PRT	Direct	Direct	C	C	0	No Deposit	303.0	NaN	Transient	103.0	1.0	Check-Out	2015-07-03	NaN
8	Resort Hotel	1	85	2015.0	July	27	1	3	2	BB	PRT	Online TA	TA/TO	A	A	0	No Deposit	240.0	NaN	Transient	82.0	1.0	Canceled	2015-05-06	NaN
9	Resort Hotel	1	75	2015.0	July	27	1	3	2	HB	PRT	Offline TA/TO	TA/TO	D	D	0	No Deposit	15.0	NaN	Transient	105.5	0.0	Canceled	2015-04-22	NaN

	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	booking_changes	deposit_type	agent	company	days_in_waiting_list	customer_type	adr	required_car_parking_spaces	total_of_special_requests	reservation_status	reservation_status_date	kids
58885	City Hotel	1	605	2016.0	October	43	17	1	2	2	BB	PRT	Groups	TA/TO	A	A	0	Non Refund	1.0	NaN	0.0	Transient	60.00	0.0	0.0	Canceled	2016-09-20	NaN
58886	City Hotel	1	605	2016.0	October	43	17	1	2	2	BB	PRT	Groups	TA/TO	A	A	0	Non Refund	1.0	NaN	0.0	Transient	60.00	0.0	0.0	Canceled	2016-09-20	NaN
58887	City Hotel	1	605	2016.0	October	43	17	1	2	2	BB	PRT	Groups	TA/TO	A	A	0	Non Refund	1.0	NaN	0.0	Transient	60.00	0.0	0.0	Canceled	2016-09-20	NaN
58888	City Hotel	1	605	2016.0	October	43	17	1	2	2	BB	PRT	Groups	TA/TO	A	A	0	Non Refund	1.0	NaN	0.0	Transient	60.00	0.0	0.0	Canceled	2016-09-20	NaN
58889	City Hotel	1	605	2016.0	October	43	17	1	2	2	BB	PRT	Groups	TA/TO	A	A	0	No Refund	1.0	NU	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
58890	Resort Hotel	0	3	2016.0	April	16	11	1	0	1	BB	PRT	Online TA	TA/TO	A	A	0	No Deposit	240.0	NaN	0.0	Transient-Party	56.00	0.0	1.0	Check-Out	2016-04-12	NaN
58891	Resort Hotel	1	158	2016.0	May	20	8	2	2	2	BB	PRT	Direct	Direct	F	F	2	No Deposit	250.0	NaN	0.0	Transient	83.05	0.0	1.0	Canceled	2016-01-21	NaN
58892	City Hotel	1	18	2016.0	August	32	6	2	2	2	BB	ESP	Online TA	TA/TO	A	A	0	No Deposit	9.0	NaN	0.0	Transient	151.00	0.0	2.0	Canceled	2016-07-28	NaN
58893	Resort Hotel	1	383	2016.0	October	41	6	1	3	2	BB	PRT	Groups	TA/TO	A	A	0	No Deposit	315.0	NaN	0.0	Transient-Party	48.00	0.0	0.0	Canceled	2016-03-04	NaN
58894	City Hotel	1	185	2016.0	July	28	5	0	4	2	BB	DEU	Online TA	TA/TO	A	A	0	No Deposit	9.0	NaN	0.0	Transient	90.95	0.0	1.0	Canceled	2016-05-31	NaN

Duplicate rows

Most frequently occurring

	hotel	is_canceled	lead_time	arrival_date_year	arrival_date_month	arrival_date_week_number	arrival_date_day_of_month	stays_in_weekend_nights	stays_in_week_nights	adults	meal	country	market_segment	distribution_channel	reserved_room_type	assigned_room_type	deposit_type	agent	days_in_waiting_list	customer_type	adr	reservation_status	reservation_status_date	kids	# duplicates
1309	City Hotel	1	188	2016.0	June	25	15	0	2	1	BB	PRT	Offline TA/TO	TA/TO	A	A	Non Refund	119.0	39.0	Transient	130.0	Canceled	2016-01-18	NaN	91
1219	City Hotel	1	158	2016.0	May	22	24	0	2	1	BB	PRT	Groups	TA/TO	A	A	Non Refund	37.0	31.0	Transient	130.0	Canceled	2016-01-18	NaN	77
733	City Hotel	1	37	2016.0	October	42	13	0	3	2	BB	PRT	Offline TA/TO	TA/TO	A	A	No Deposit	56.0	0.0	Transient-Party	105.0	Canceled	2016-09-06	NaN	75
740	City Hotel	1	39	2015.0	August	33	14	0	2	2	HB	PRT	Offline TA/TO	TA/TO	A	A	No Deposit	6.0	0.0	Transient-Party	101.5	Canceled	2015-07-06	NaN	68
886	City Hotel	1	71	2016.0	June	25	14	0	3	1	BB	PRT	Offline TA/TO	TA/TO	A	A	Non Refund	236.0	0.0	Transient	120.0	Canceled	2016-04-27	NaN	68
550	City Hotel	1	1	2016.0	February	10	28	2	1	1	BB	PRT	Offline TA/TO	TA/TO	A	A	No Deposit	134.0	0.0	Transient-Party	60.0	Canceled	2016-02-27	NaN	63
960	City Hotel	1	87	2015.0	September	39	25	2	3	2	BB	PRT	Groups	TA/TO	A	A	Non Refund	1.0	0.0	Transient	170.0	Canceled	2015-09-09	NaN	59
812	City Hotel	1	56	2016.0	June	24	8	0	1	2	BB	PRT	Offline TA/TO	Corporate	A	A	No Deposit	191.0	0.0	Transient-Party	120.0	Canceled	2016-06-02	NaN	55
905	City Hotel	1	74	2015.0	September	38	18	0	2	2	HB	PRT	Offline TA/TO	TA/TO	A	A	Non Refund	6.0	0.0	Transient-Party	101.5	Canceled	2015-07-06	NaN	54
1055	City Hotel	1	105	2016.0	April	15	6	0	1	2	BB	PRT	Offline TA/TO	TA/TO	A	A	Non Refund	12.0	0.0	Transient	75.0	Canceled	2016-01-18	NaN	52

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters